/*
 Navicat Premium Data Transfer

 Source Server         : mysql-local
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : localhost:3306
 Source Schema         : mlp

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 16/11/2024 02:29:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for groupd
-- ----------------------------
DROP TABLE IF EXISTS `groupd`;
CREATE TABLE `groupd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分组名称',
  `level` tinyint(4) DEFAULT NULL COMMENT '等级',
  `pid` int(11) DEFAULT NULL COMMENT '父节点',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态：1-可用；0-禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分组表';

-- ----------------------------
-- Records of groupd
-- ----------------------------
BEGIN;
INSERT INTO `groupd` (`id`, `name`, `level`, `pid`, `status`) VALUES (10, '高原站点', 1, NULL, 1);
INSERT INTO `groupd` (`id`, `name`, `level`, `pid`, `status`) VALUES (11, '地面站点', 1, NULL, 1);
INSERT INTO `groupd` (`id`, `name`, `level`, `pid`, `status`) VALUES (12, '公园站点', 1, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单名称',
  `level` int(11) DEFAULT NULL COMMENT '级别',
  `pid` int(11) DEFAULT NULL COMMENT '父节点',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '页面路径',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态：1-可用；0-禁用',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单表';

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `name`, `level`, `pid`, `sort`, `path`, `status`, `remark`) VALUES (1, 'weather', 1, NULL, 1, '/weather/list', 1, '环境监测');
INSERT INTO `menu` (`id`, `name`, `level`, `pid`, `sort`, `path`, `status`, `remark`) VALUES (2, 'data', 1, NULL, 2, '/data/list', 1, '数据统计');
INSERT INTO `menu` (`id`, `name`, `level`, `pid`, `sort`, `path`, `status`, `remark`) VALUES (3, 'device', 1, NULL, 3, '/device/list', 0, '设备管理');
INSERT INTO `menu` (`id`, `name`, `level`, `pid`, `sort`, `path`, `status`, `remark`) VALUES (4, 'group', 1, NULL, 4, '/group/list', 0, '站点管理');
INSERT INTO `menu` (`id`, `name`, `level`, `pid`, `sort`, `path`, `status`, `remark`) VALUES (5, 'user', 1, NULL, 5, '/user/list', 1, '用户管理');
COMMIT;

-- ----------------------------
-- Table structure for param
-- ----------------------------
DROP TABLE IF EXISTS `param`;
CREATE TABLE `param` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) DEFAULT NULL COMMENT '分组id',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '参数名称',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型：1-气象',
  `unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '计量单位',
  `precision` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '精度',
  `resolution` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分辨力',
  `range` text COLLATE utf8mb4_unicode_ci COMMENT '参数范围',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '说明',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态：1-可用；0-禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='参数表';

-- ----------------------------
-- Records of param
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色名称',
  `permission` text COLLATE utf8mb4_unicode_ci COMMENT '角色权限，这里只保存菜单权限',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态：0-禁用；1-可用；',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `permission`, `status`) VALUES (1, '管理员', 'all', 1);
INSERT INTO `role` (`id`, `name`, `permission`, `status`) VALUES (2, '普通用户', '1,2,3', 1);
COMMIT;

-- ----------------------------
-- Table structure for syslog
-- ----------------------------
DROP TABLE IF EXISTS `syslog`;
CREATE TABLE `syslog` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `options` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作说明',
  `type` int(11) DEFAULT NULL COMMENT '操作类型：0-登录；',
  `log_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '日志详情',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户id',
  `user_ip` varchar(255) DEFAULT NULL COMMENT '操作ip',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志表';

-- ----------------------------
-- Records of syslog
-- ----------------------------
BEGIN;
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (7, '用户登录', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-11 23:30:06');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (8, '用户登录', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-11 23:34:57');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (9, '用户登录', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-11 23:35:40');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (10, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 01:34:00');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (11, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 01:46:19');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (12, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 01:55:17');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (13, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:04:21');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (14, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:13:29');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (15, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:13:55');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (16, '修改密码', 11, '用户(admin)修改密码', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:17:37');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (17, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:20:00');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (18, '修改密码', 11, '用户(admin)修改密码', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:20:12');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (19, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-12 02:20:16');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (20, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 01:15:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (21, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 01:27:35');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (22, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 01:54:37');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (23, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 04:24:17');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (24, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 05:56:40');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (25, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:16:23');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (26, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:19:34');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (27, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:25:15');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (28, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:27:02');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (29, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:27:45');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (30, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:28:55');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (31, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:30:29');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (32, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:30:58');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (33, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:36:52');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (34, '添加用户', 12, '用户(admin)添加用户', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:37:12');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (35, '重置密码', 14, '用户(admin)重置用户(老刘)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:39:51');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (36, '重置密码', 14, '用户(admin)重置用户(老刘)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:41:41');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (37, '删除用户', 13, '用户(admin)删除用户：dddd', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:41:50');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (38, '重置密码', 14, '用户(admin)重置用户(老刘)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:41:58');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (39, '重置密码', 14, '用户(admin)重置用户(老王)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:42:01');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (40, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:51:55');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (41, '重置密码', 14, '用户(admin)重置用户(老王)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:52:39');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (42, '重置密码', 14, '用户(admin)重置用户(老刘)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:52:42');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (43, '登录平台', 10, '用户(老王)登录平台', 21, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:52:57');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (44, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2022-07-13 08:53:11');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (45, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-04 22:00:38');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (46, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 20:46:11');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (47, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 21:02:25');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (48, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 21:14:52');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (49, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 21:17:05');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (50, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:25:05');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (51, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:27:29');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (52, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:28:37');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (53, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:30:07');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (54, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:31:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (55, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:32:21');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (56, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:33:50');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (57, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:53:07');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (58, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:55:45');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (59, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:56:51');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (60, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-05 23:57:46');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (61, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 00:01:41');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (62, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 22:08:56');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (63, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 22:34:23');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (64, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 23:15:24');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (65, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 23:24:53');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (66, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-06 23:26:42');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (67, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 00:00:09');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (68, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 00:18:06');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (69, '重置密码', 14, '用户(admin)重置用户(老王)密码：111111', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 01:15:25');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (70, '登录平台', 10, '用户(老王)登录平台', 21, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 01:16:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (71, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 01:27:11');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (72, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-08 03:01:22');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (73, '登录平台', 10, '用户(admin)登录平台', 1, '192.168.31.79', NULL, '2024-11-09 01:30:21');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (74, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 00:39:54');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (75, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 00:41:47');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (76, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 00:44:30');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (77, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 00:56:09');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (78, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:16:39');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (79, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:21:28');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (80, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:26:03');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (81, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:33:25');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (82, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:36:55');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (83, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:42:02');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (84, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:43:53');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (85, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:46:41');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (86, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:48:08');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (87, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:52:16');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (88, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:55:12');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (89, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 01:59:19');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (90, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 02:02:01');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (91, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 02:03:09');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (92, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 02:06:32');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (93, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 02:07:36');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (94, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 21:28:03');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (95, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 21:29:18');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (96, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 21:36:38');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (97, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-12 22:18:48');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (98, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 22:23:24');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (99, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 22:43:11');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (100, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 23:20:57');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (101, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 23:25:12');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (102, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 23:29:07');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (103, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 23:38:30');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (104, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-13 23:54:56');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (105, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:00:11');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (106, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:04:18');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (107, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:08:31');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (108, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:11:40');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (109, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:14:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (110, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:23:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (111, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:27:02');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (112, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:49:25');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (113, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 00:54:26');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (114, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 01:00:03');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (115, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 01:11:50');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (116, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 01:27:49');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (117, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 01:30:06');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (118, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 01:34:06');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (119, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:06:15');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (120, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:09:51');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (121, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:11:55');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (122, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:15:00');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (123, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:16:10');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (124, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:18:36');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (125, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:21:50');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (126, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:36:53');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (127, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:38:59');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (128, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:41:53');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (129, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:46:13');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (130, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:47:25');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (131, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:48:13');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (132, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:50:03');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (133, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:51:36');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (134, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:52:39');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (135, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:53:40');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (136, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-14 02:57:22');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (137, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-16 00:52:44');
INSERT INTO `syslog` (`id`, `options`, `type`, `log_info`, `user_id`, `user_ip`, `remark`, `create_time`) VALUES (138, '登录平台', 10, '用户(admin)登录平台', 1, '0:0:0:0:0:0:0:1', NULL, '2024-11-16 01:05:28');
COMMIT;

-- ----------------------------
-- Table structure for tagdata
-- ----------------------------
DROP TABLE IF EXISTS `tagdata`;
CREATE TABLE `tagdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标记id',
  `project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '项目名称',
  `project_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '项目号',
  `test_organize` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测机构名称',
  `test_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '采样时间',
  `env_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '环境要素类别:1大气；2地表水；3地下水；4土壤（建设项目）；5土壤（农用地）；',
  `test_point_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测点名称',
  `test_point_lng` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测点经度',
  `test_point_lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测点纬度',
  `test_item` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测项目',
  `test_value` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测值',
  `daily_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '日均值',
  `protect_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '对应保护级别',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '达标情况',
  `over_times` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '超标倍数',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `tag_type` tinyint(255) NOT NULL DEFAULT '1' COMMENT '标记类别:1标记；2线段；3多边形；4圆形；',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `index_lng_lat_password` (`test_point_lng`,`test_point_lat`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据表';

-- ----------------------------
-- Records of tagdata
-- ----------------------------
BEGIN;
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (33, '111', '222', '333', '2020-06-16 08:00:00', '2,3', '555', '112.16478', '30.34147', '', '', '', '', '', '', NULL, '2024-11-14 02:07:20', 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (38, '咕咕咕', '99', '有的', '2024-11-21 08:00:00', '2,5', '这里', '112.22843', '30.34624', '', '', '', '', '', '', NULL, '2024-11-14 01:35:23', 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (39, 'test', 'ttt', 'yy', '2021-07-08 08:00:00', '2,4,5', 'rrr', '112.29023', '30.32402', 'xxx', '1\n2\n3\n4', '3', 'xxx', '超标', '9', NULL, '2024-11-14 02:58:25', 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (40, '水边草地', '666', '三遍坡', '2024-11-13 08:00:00', '2,4', '嘿嘿嘿', '112.18998', '30.30031', '', '', '', '', '', '', '2024-11-13 23:25:52', NULL, 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (41, 'aptapt', 'jkjk', 'ffff', '2024-11-21 08:00:00', '2,3', 'ggg', '112.25659', '30.30179', '', '', '', '', '超标', '18', '2024-11-13 23:33:29', NULL, 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (42, '哈哈哈', '饭饭饭', '对对对', '2024-11-13 08:00:00', '1,2,3,4', 'fff', '112.26478', '30.29646', '', '', '', '', '超标', '55', '2024-11-13 23:43:11', NULL, 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (43, '沙市河边', '建军节', '对对对', '2024-11-14 08:00:00', '2,4', '饭饭饭', '112.24658', '30.30831', '', '', '', '', '超标', '30', '2024-11-14 00:15:23', NULL, 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (44, '对对对', '滴滴滴', '等得到', '2024-11-14 08:00:00', '4', '到', '112.25070', '30.30594', '', '', '', '', '', '', '2024-11-14 00:24:29', NULL, 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (45, '困困困', '咳咳咳', 'kkk', '2020-01-28 08:00:00', '4', '卡卡卡', '112.16316', '30.32046', '', '', '', '', '', '', NULL, '2024-11-14 02:06:59', 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (46, '对对对', '滴滴滴', '等得到', '2024-11-14 08:00:00', '4', '到', '112.25070', '30.30594', '', '', '', '', '超标', '333', NULL, '2024-11-14 00:29:03', 1, NULL);
INSERT INTO `tagdata` (`id`, `project_name`, `project_number`, `test_organize`, `test_time`, `env_type`, `test_point_name`, `test_point_lng`, `test_point_lat`, `test_item`, `test_value`, `daily_value`, `protect_level`, `status`, `over_times`, `create_time`, `modify_time`, `tag_type`, `remark`) VALUES (47, 'jjj', '建军节', '急急急', '2020-02-05 08:00:00', '3', '借鉴借鉴', '112.18037', '30.29942', '', '', '', '', '', '', NULL, '2024-11-14 02:07:52', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_type` tinyint(255) NOT NULL DEFAULT '1' COMMENT '用户类型:1管理员；2用户；',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名称',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '登录密码',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号码',
  `avatar_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像保存路径',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实姓名',
  `gender` int(11) DEFAULT NULL COMMENT '性别：0-女；1-男；',
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '国家',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '城市',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司',
  `language` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '语言',
  `open_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信用户唯一ID',
  `balance` int(11) DEFAULT '0' COMMENT '钱包余额（单位：分）',
  `bonus_points` int(11) DEFAULT NULL COMMENT '用户积分',
  `group_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '分组id',
  `status` tinyint(4) DEFAULT '1' COMMENT '用户状态：1正常；0异常；-1限制登录',
  `login_times` int(11) DEFAULT '0' COMMENT '登录次数',
  `last_login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最后登录IP',
  `last_login_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '最后登录时间',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '注册时间',
  `modify_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `index_user_name_password` (`user_name`,`password`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `user_type`, `user_name`, `password`, `phone`, `avatar_url`, `nick_name`, `real_name`, `gender`, `country`, `province`, `city`, `company`, `language`, `open_id`, `balance`, `bonus_points`, `group_id`, `status`, `login_times`, `last_login_ip`, `last_login_time`, `create_time`, `modify_time`, `remark`) VALUES (1, 1, 'admin', '4a78b66a0e09850c6f9c5a3d58a43205', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, 0, '0:0:0:0:0:0:0:1', '2024-11-16 01:05:28', '2024-11-05 20:46:41', '2024-11-16 01:05:28', '111111');
INSERT INTO `user` (`id`, `user_type`, `user_name`, `password`, `phone`, `avatar_url`, `nick_name`, `real_name`, `gender`, `country`, `province`, `city`, `company`, `language`, `open_id`, `balance`, `bonus_points`, `group_id`, `status`, `login_times`, `last_login_ip`, `last_login_time`, `create_time`, `modify_time`, `remark`) VALUES (21, 2, '老王', '4a78b66a0e09850c6f9c5a3d58a43205', '15658838007', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '10,11', 1, 0, '0:0:0:0:0:0:0:1', '2024-11-08 01:16:10', '2022-07-13 08:23:08', '2024-11-08 01:16:10', '高原站点,地面站点');
INSERT INTO `user` (`id`, `user_type`, `user_name`, `password`, `phone`, `avatar_url`, `nick_name`, `real_name`, `gender`, `country`, `province`, `city`, `company`, `language`, `open_id`, `balance`, `bonus_points`, `group_id`, `status`, `login_times`, `last_login_ip`, `last_login_time`, `create_time`, `modify_time`, `remark`) VALUES (22, 2, '老刘', '4a78b66a0e09850c6f9c5a3d58a43205', '18355326032', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '10,11,12', 1, 0, NULL, '2022-07-13 08:23:06', '2022-07-13 08:23:06', '2022-07-13 08:52:42', '高原站点,地面站点,公园站点');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
